ADOxx Browser ​

The browser included in ADOxx provides an overview so work can be distributed and further work (printing, saving, ...) can be carried out. Regardless of where you are in ADOxx, the ADOxx browser provides a standard layout.

The ADOxx browser is used in the Library administration and the Attribute profile administration.

General information with regard to the ADOxx browser:

• Classification
• Structure

Functions in the ADOxx browser:

• show model name in each row
• enter/adjust column width
• enter/adjust height of row
• expand/shrink
• select attributes/columns
• sort
• adjust attribute values in columns
• show (attribute)values
• open Notebook
• search
• save
• copy table
• print
• diagram representation

ADOxx Browser - Classification ​

In ADOxx different types of browsers are available. They fall into the following categories:

• hierarchical and
• non-hierarchical browsers

on one hand, characterising the visible data structure and:

• editable and
• non-editable browsers

on the other hand, characterising the accessibility of the data.

The data in an editable browser can be edited and stored in the database while the data in a non-editable browser only serves for showing results of various kinds.

The data in a hierarchical browser is shown in different hierarchy levels (e.g. a model and its sub models) while data in a non-hierarchical browser is shown as a plain list structure.

Every ADOxx browser has a combination of these classification characteristics (hierarchical and editable), depending on the data presented. This results in four different property combinations.

Examples:

• editable/hierarchical (here: analysis result):
  
• editable/non-hierarchical (here: Tabular Model Editor):
  
• non-editable/hierarchical (here: capacity analysis simulation result):
  
• non-editable/non-hierarchical (here: path analysis simulation result):
  

ADOxx Browser - Structure ​

The ADOxx Browser window displays data (e.g. results) in a tabular form and offers the functionality to save, print and display the data graphically.

General structure:

The column headings (first row, grey background) show the type of data for the respective column (e.g. the name of the attribute shown in this column).

The first column (grey background) contains the row structuring and the labelling for every set of data (row).

The rows contain one set of data each. Every set of data consists of one or more cells.

The cells show the appropriate attribute values or calculation results.

The following picture shows an example of a query result displayed in the ADOxx Browser. In the title bar of the browser you can find information on the contents shown:

Hierarchical browsers:

In hierarchical ADOxx browsers a number indicating the hierarchy level is shown in the (grey) header of each row. The display area (white background) contains the results.

The row and column structure of the browser, the labelling and the cell contents depend on the type of information shown. Depending on the content hierarchical browsers may contain empty cells.

Editable browsers:

In editable ADOxx browsers, the values in the cells can be edited. The availability of this function depends both on the data and the write access state on the models supplying the data.

For example, you can edit the results of an Analysis query directly in the ADOxx Browser, if you have previously opened the queried models with write access. Write-protected attributes are shown in grey.

Browser functions:

The context menu (right mouse button) in the ADOxx browser contains among other things the following functions:

• Notebook : Opens the Notebook of an object.
• Expand all : show the entire contents of the browser by expanding all areas,
• Shrink all : only shows the highest level,
• Save : save the contents of the browser in a file,
• Print : print the contents of the browser as currently displayed (WYSIWYG),
• Find : search for specific text within the browser,
• Copy to clipboard : copy the contents of the browser to the clipboard,
• Select attributes/columns : select the columns, which have to be shown (attributes),
• Sort : sort the browser contents,
• Show model name in each row : shows the name of the corresponding model in each row,
• Column width : enter the column width,
• Adjust column width : adjust the width of the columns to the optimum size,
• Row height : enter the row height,
• Adjust row height : adjust the height of the rows to the optimum size.

The context menu (right mouse click) for the column header in general contains the following functions:

• align attribute values: align the attribute value of the current column to the left, centre it or to the right,

• sort ascending/descending: ascending or descending sorting of the attribute values of the current column.

Information on representation of attribute values is available in ADOxx Browser - Representation of Attribute Values

ADOxx Browser - Show Model Name in Each Row ​

When you select the menu item "Show model name in each row" in the ADOxx browsers popup menu (right mouse button), the name of the corresponding model will be shown in each row.

ADOxx Browser - Enter Column Width ​

The ADOxx browser enables the user to define the width of any column. To enter a column width, place the mouse pointer on the appropriate column, open the context menu (right mouse button) and select the "Column width" menu item.

In the "Set column width", the current column width is shown in the "width" field.

Enter the value of the column width and then click on the OK button.

ADOxx Browser - Adjust Column Width ​

Within the ADOxx browser it is possible to dynamically adjust the width of any row. In order to do this, place the mouse pointer at the division point between two columns in the header column.

The mouse pointer will change to when it is placed in the correct place. Once the mouse pointer changes, it is possible to increase or decrease the width of a column by pressing and holding the left mouse button and moving the mouse in the required direction. In this way it is possible to display the results in columns wider than the standard maximum.

It is also possible to adjust the width of a particular column by double-clicking in the header of that column (this will adjust it to the optimal width).

ADOxx Browser - Enter Row Height ​

The ADOxx browser enables the user to define the height of any rows. To enter a row height, place the mouse pointer on the appropriate row, open the context menu (right mouse button) and select the "Row height" menu item.

In the "Set row height" window , the current number of visible rows is shown in the "Row" field.

Enter the number of rows you want to display and then click on the OK button.

ADOxx Browser - Adjust Row Height ​

With the ADOxx browser it is possible to dynamically adjust the width of any column, so that cells that contain several lines can be shown completely.

To adjust a row height, place the mouse pointer on the division line between two rows in the first column.

The mouse pointer will change to when it is placed in the correct place. Once the mouse pointer changes, it is possible to change the height of a row by pressing and holding the mouse button and moving the mouse in the required direction. In this way it is possible to display results containing line breaks.

ADOxx Browser - Expand / Shrink All ​

The ADOxx browser stores the output of queries, Capacity and Workload Analysis in groups (e.g. models). In order to present an overview to the user and to allow the user to find particular results quickly. These groups can then be expanded (or shrunk) to display more detail.

Unexpanded rows are characterised by the symbol . By clicking on this symbol, the rows will be expanded and this symbol will be shown.

To restore to the original state click on the symbol again and it will change from to .

ADOxx Browser - Select Attributes/Columns ​

With the ADOxx browser it is possible for specific displays to shrink or expand any columns with attribute values or evaluation results

Select attributes

To select the attributes to display (i.e. columns with attribute values), open the context menu of the browser (right mouse button) and select the "Select attributes" menu item. A window will be displayed , in which all the attributes that can be displayed are shown following the notebook structure.

Select the attributes that the sort should be applied to and then click on the OK button.

Select columns

To select the columns to display, open the context menu of the browser (right mouse button) and select the "Select columns" menu item. All columns, that can be displayed in the browser are shown in the "Select visible columns" window.

Select the columns you want to display and click on the OK button.

ADOxx Browser - Open Notebook ​

In the tabular model editor, the capacity analysis and the workload analysis you can open the notebook of objects and connectors via the context menu. You can also use the following key combination <Ctrl> + <Alt> + <Shift> + double click.

ADOxx Browser - Sort ​

In the ADOxx browser, it is possible for specific displays to sort the browser contents using the attribute values displayed (within a column).

To sort the browser contents displayed move the mouse to the top of the column and select the menu item "Sort (ascending)" or "Sort (descending)" from the context menu of the browser (right mouse button).

In addition it is possible to select the attribute to use (= column) for the sort using a dialogue for selection. In this case open the context menu of the browser (right mouse button, the mouse pointer must not be on the header of a column) and choose the menu point "Sort".

ADOxx Browser - Sort by Attribute Columns ​

After selecting the menu point "Sort" within the context menu of the browser, all attribute columns within the respective notebook structure are displayed.

Select the attribute, according to which the sort should be ordered by and then click on the OK button.

ADOxx Browser - Align Attribute Values ​

The ADOxx browser offers the possibility to align the displayed attribute values of a column

• left,
• centred or
• right.

Align the values of a column by moving the mouse to the top of the column, open the context menu (right mouse click) and select the alignment ("Left","Centred" or "Right").

ADOxx Browser - Show/Edit (Attribute) Values ​

For improved readability, for editing or for showing additional information, you can display (attribute) values in a separate window.

If you want to show a (attribute) value, double-click on the cell with the (attribute) value to display and the following window will be opened.

You can save the displayed (attribute) value to a file ("Save" button) or print it out ("Print" button).

ADOxx Browser - Search ​

Using the button "Search" (or the corresponding item in the popup menu) you can search for a specific piece of text in the browser (in all expanded rows). The window "Search for browser contents" is displayed after clicking on this button.

Enter the text (character or expression) for which you would like to search for, into the input field "Text".

The following options are available for your search:

• Match case: when this option is selected the search will differentiate between upper and lower case letters.
• Regular expression: the default is to deactivate this option when searching for standard text. However by activating "Regular expression" you can search the contents with the help of special characters.

In addition, the following options are also available when searching for text:

• Subtext: means that the text being searched for can be part of a larger word or sentence.
• Full text: this is the default option - finds all cells which match exactly the full text being searched for.
• Word: finds all texts where the text being searched occurs as a single word (may be bounded by blanks or a full stop).

Clicking on the button "Search" begins the actual search. Each row, which is matched successfully during a search, will be highlighted in red.

ADOxx Browser - Save ​

With the "Save" button you can save the displayed results to a file. After clicking the button, the dialogue window "Save - Options" appears:

Within the dialogue window you can select:

• Settings
• File formats for external data

that define both format and contents of the export file.

In addition you have to enter the filename and path to which the results should be saved in the input field "File name".

Click "OK" to continue.

ADOxx Browser - Save Settings ​

The "Settings" allow you to influence the contents of the file being saved. The following options are available:

Header:
When this option is activated, a header is automatically added to the top of the save file, which contains general information (e.g. the result type, the time stamp and the like).

Time as number:
If this option is activated, then attributes which are currently saved in the ADOxx time format YY:DDD:HH:MM:SS will be converted to seconds in the file (e.g. the expression 00:000:00:30:00 will be converted to 1800 seconds).

Save as expanded:
Select this option to save the whole contents of a hierarchical ADOxx browser - regardless which branches are currently expanded and which are collapsed. If the option is deactivated, then only the current view is saved to the file. Note: This option is only available if the browser tree is not fully expanded anyway.

Append:
The contents of the browser are appended to the bottom of an already existing file.

Model name in each row:
If activated, then the name of the model in question is placed at the beginning of every single row/line of the output file. If the option is deactivated, then the model name appears only at the beginning of the model contents listing.

Save model numbering:
Activating this option saves the model numbering.

Save model numbering in separate column:
If "Save model numbering" is activated the option to save the model numbering in a separate column is available.

Example:
A short CSV file generated with deactivated option "Model name in each row" could look like this: "";"Execution Time" "1. Refusal";"" "File Application";"00:000:00:05:00" "Inform Applicant";"00:000:00:01:30"

With activated options "Time as number" and "Model name in each row" the file would be structured like this: "";"";"Execution Time" "1. Refusal";"";"" "1. Refusal";"File Application";"300,000000" "1. Refusal";"Inform Applicant";"90,000000"

ADOxx Browser - Save Formats ​

By clicking on the file format list, you can select the type of file in which the results should be saved. It is very important to choose the correct format especially when you wish to work further on the results in a spreadsheet program (e.g. Microsoft Excel)

You can save the results

• for Spreadsheet (*.txt),
• for Spreadsheet (*.csv),
• for Word processor (*.txt),
• in Rich Text Format (*.rtf),
• as HTML file (*.htm) or
• as comparing representation (*.acr)

ADOxx Browser - Copy to Clipboard ​

When you select the menu item "Copy to clipboard" in the ADOxx browsers popup menu (right mouse button), the contents currently displayed in the ADOxx browser are copied to the clipboard and can then be pasted into Microsoft Excel for example in order to carry out some further work or calculations.

ADOxx Browser - Print ​

In order to print the results displayed in the ADOxx browser, click on the button "Print". This will cause the window "Print" to be displayed:

Print:

The field "Print" contains a list of all available printers. Select a printer from the list (default printer is pre-selected). The printer settings can be checked and if necessary changed by clicking on the smart icon . If any problem with printers occur contact your system administrator.

Choose your settings for**"Page layout"**, "Layout parameters" and "Scale".

The window "Preview and page selection" is updated with each change. This print preview helps to choose pages for the printout (by allowing the user to mark the pages that aren't to be printed).

In the status line you will find information about the printout of several pages depending on the current layout and scale (total number of pages, number of selected pages, numbering of selected pages).

To start printing click "Print". In the status window, you will find information about current printing status. By clicking on the "Cancel" button, the printing process will be cancelled immediately.

ADOxx Browser - Diagram ​

In the window "<Browser content> - Diagram settings" you can define the settings for the graphical display of results.

Select the objects and attributes to be displayed.

Define either an "object" or an "attribute" basis for the results display. The "object" option basis shows the selected attribute per object. The "attribute" option basis gives the selected objects per attribute.

The type of diagram sets the type of graphical display. It is possible to display the results either as a bar diagram or a Pie chart. The bar diagram shows a group per value with a bar for each result. The pie diagram shows the part of each result for the selected value.

Once you have chosen the selected settings, click on the "Display" button. In the "Result comparison - graphical display" window, the results will be shown as graphics. If the graphical representation is bigger than the drawing area in the window, a scroll-bar will also be available to enable you to see the entire diagram.

On the right of the graphical result display you will find options for the following general layout settings, which are available for both types of diagram:

• "Value": When this option is selected, the appropriate values - in time or number format - are included in the graphical display.
• "Legend": By activating this option, the diagram will be described more precisely using a legend.
• "Axis labels": By activating this option, the axis of the diagram will be labelled.
• "Items per page": This refers to the number of items shown on one page. Changing this value can give you a better overview of the diagram. By reducing the number of items per page, the un-displayed items will be moved onto the next page.
• "Page": The page number of the current page is displayed. Changes to the field "Items per page" causes the total number of pages to change. If, for example the number of entries per page is reduced from 15 to 10, then the number of pages may be increased from 1 to 2.

You can copy or print the displayed diagram to the clipboard or to a graphic file.

By clicking on the "cancel" button you will close the graphical result display.

ADOxx Browser - Diagram - Bar Diagram ​

Results displayed in a bar diagram show several attributes of a type, (time or number) with their attribute values. The attributes will be displayed in a legend on the left upper side of the graphical results window.

On the right of the graphical result display you will find options for the following general layout settings:

• "Value": When this option is selected, the appropriate values - in time or number format - are included in the graphical display.

• "Legend": By activating this option, the diagram will be described more precisely using a legend.

• "Axis labels": By activating this option, the axis of the diagram will be labelled.

• "Items per page": This refers to the number of items shown on one page, changing this value can give you a better overview of the diagram. By reducing the number of items per page, the remaining items will be moved onto the next page.

• "Page": The page number of the current page is displayed. Changes to the field "Items per page" causes the total number of pages to change. If, for example, the number of entries per page is reduced from 15 to 10, then the number of pages may be increased from 1 to 2.

You can save the displayed diagram to the clipboard or copy or print it to a graphic file.

Click on the "Settings" button, to change the settings for the bar diagram display.

In the "Part to display" window you can limit the bar diagram to a specific area by entering a lower and/or an upper limit. (For ''time" attributes, the lower and the upper limit will be measured in seconds.)

The**"Mark" field** options enables better graphical editing of the files. You can click and select one of the following options for the display of the scale:

• "Equal" divides the length of the bar diagram in equal sections.
• "Min" marks the smallest attribute value.
• "Maximum" marks the largest attribute value.
• "Without" shows the diagram without divisions.

Click on the "Display" button to show the bar diagram with the changed settings.

ADOxx Browser - Diagram - Pie Chart ​

Only one attribute can be displayed within a pie chart.

Each section of the pie chart contains a number, which refers to the name of the entry, its value and its percentage of the total sum. They are displayed in a tabular form, below the pie chart.

To the right of the graphical representation the following options are available:

• "Values": When this option is selected, the appropriate values - in time or number format - are included in the graphical display.
• "Legend": By activating this option, the diagram will be described more precisely using a legend.
• "Page": The page number of the current page is displayed. Changes to the field "Items per page" causes the total number of pages to change. If, for example, the number of entries per page is reduced from 15 to 10, then the number of pages may be increased from 1 to 2.

Diagram - Generate Graphics ​

The button "Generate graphics" allows you to copy the displayed diagram onto the clipboard or to store it as either a BMP file (1-bit or 24-bit), a PCX file(8-bit or 24-bit) or a JPG file (24-bit), PNG file (24-bit) or. EMF file (24-bit).

Clicking on this button causes the window "Generate graphics" to be displayed.

Select the destination to which the graphic should be copied. If the clipboard is selected, no more options need to be set.

If copying to a file, then you must enter a path and filename in the field "Filename". Additionally, you can select the size of the graphic to be generated in the field "Scale" and the type of graphic in the field "Graphic format".

Click on the button "Generate" to actually generate the graphic.